package com.asd.system.mapper;


import com.asd.system.entity.Icon;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;

@Mapper
@Component
public interface IconMapper extends BaseMapper<Icon> {


    @Delete("delete from icon where iconEchoPath = #{iconEchoPath}")
    void deletByIconEchoPath(@Param("iconEchoPath")String iconEchoPath);

    @Select("SELECT iconEchoPath FROM icon WHERE userName =#{userName}")
    List<String> selectByUserName(@Param("userName")String userName);
}
